home *** CD-ROM | disk | FTP | other *** search
/ C++ für Kids / C++ for kids.iso / SETUP / CBUILDER / DATA.Z / DBX.DBI < prev    next >
Encoding:
Borland DataBase Explorer Information  |  1997-02-20  |  18.1 KB  |  381 lines
  1.  
  2.  
  3. [Version]
  4. DbXVersion=1.02
  5.  
  6. [Properties]
  7. NET PROTOCOL:Values1=TNS,TCP/IP,SPX/IPX,NETBIOS,NAMED PIPES,DECNET,3270,VINES
  8. NET PROTOCOL:Values2=APPC,ASYNC
  9. OPEN MODE:Values=READ/WRITE,READ ONLY
  10. SHARE MODE:Values=EXCLUSIVE,SHARED
  11. STRICTINTEGRTY:Values=FALSE,TRUE
  12. SQLPASSTHRU MODE:Values=NOT SHARED,SHARED AUTOCOMMIT,SHARED NOAUTOCOMMIT
  13. LIST SYNONYMS:Values=NONE,ALL,PRIVATE
  14. BLOB EDIT LOGGING:Values=FALSE,TRUE
  15. DEFAULT DRIVER:Values=PARADOX,DBASE
  16. ENABLE SCHEMA CACHE:Values=FALSE,TRUE
  17.  
  18.  
  19.  
  20. [Standard Properties]
  21. DriverType:Values=PARADOX="Paradox",DBASE="dBASE"
  22. BooleanYesNo:Values=0="Nein",-1="Ja"
  23. FieldVChecks:Values=0="",1="Hat Gⁿltigkeitsprⁿfungen",2=""
  24. FieldRights:Values=0="Lesen/Schreiben",1="Nur Lesen",2="Leer",3=""
  25. PrimaryIndex:Values=="<PrimΣrschlⁿssel>"
  26. LookupType:Values1=0="Leer",1="Aktuelles Feld",2="Alle entsprechenden"
  27. LookupType:Values2=3="Aktuelles Feld & Hilfe",4="Alle entsprechenden & Hilfe"
  28. ReferenceType:Values=0="Master",1="Detail"
  29. ReferenceQual:Values=0="Verhindern",1="Weitergeben"
  30. PrivilegeType:Values1=0="Leer",1="Nur Lesen",3="─ndern/Lesen",7="Einfⁿgen/─ndern/Lesen"
  31. PrivilegeType:Values2=15="L÷schen/Einfⁿgen/─ndern/Lesen",31="Alle Rechte",255=""
  32. FamilyRightsType:Values=0="Leer",1="Formular",2="Berichte",4="Gⁿltigkeitsprⁿfungen",8="Einstellungen"
  33. FamilyMemberType:Values1=0="Unbekannt",1="Tabelle",2="Indizes",3="Formular",4="Bericht"
  34. FamilyMemberType:Values2=5="Gⁿltigkeitsprⁿfungen",6="SekundΣrindex",7="SekundΣrindex"
  35. FamilyMemberType:Values3=8="Blob-Datei"
  36.  
  37. Standard:Objects=O:"Tabellen"=Table
  38.  
  39. Table:Attrs1=TYPE="Typ"::NR:VM:DriverType,DATE="Datum",TIME="Zeit",VERSION="Version":2
  40. Table:Attrs2=VALID="Gⁿltig":2::VM:BooleanYesNo,STRUCTURE="Struktur":2
  41. Table:Attrs3=PROTECTED="Geschⁿtzt":2::VM:BooleanYesNo
  42. Table:Name=FILENAME,EXTENSION
  43. Table:Objects1=O:"Felder"=Column,O:"Indizes"=Index,O:"Gⁿltigkeitsprⁿfungen"=ValCheck
  44. Table:Objects2=O:"Referenzielle Bedingungen"=Reference,O:"Sicherheitseinstellungen"=Security
  45. Table:Objects3=O:"Tabellendateien"=Family
  46.  
  47. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  48. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  49. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  50.  
  51. Column:Attrs1=TYPE="Typ":1:NR,UNITS1="Gr÷▀e":1:N,UNITS2="Skala":1:N
  52. Column:Attrs2=LENGTH="Physikalische LΣnge"
  53. Column:Name=NAME
  54.  
  55. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  56. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  57. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  58. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  59. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  60. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  61.  
  62. Index:Attrs1=NAME=Name:0::VM:PrimaryIndex,TAGNAME=Tag:0,RESTRNUM="Version":2
  63. Index:Attrs2=PRIMARY="PrimΣrschlⁿssel":::VM:BooleanYesNo,UNIQUE="Eindeutig"::NR:VM:BooleanYesNo
  64. Index:Attrs3=AUTO="Gewartet":2::VM:BooleanYesNo
  65. Index:Attrs4=OUTOFDATE="Veraltet":2::VM:BooleanYesNo
  66. Index:Attrs5=FORMAT="Format":2,BLOCKSIZE="Blockgr÷▀e":2
  67. Index:Attrs6=CASEINSENSITIVE="Ohne Gro▀-/Kleinschreibung":2:NR:VM:BooleanYesNo
  68. Index:Attrs7=DESCENDING="Absteigend":2:NR:VM:BooleanYesNo
  69. Index:Attrs8=EXPRESSION="Ausdruck":2:N
  70. Index:Attrs9=CONDITION="Unterbedingung":2:N
  71. Index:Name=Name,Tag
  72.  
  73. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  74. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  75. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  76. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  77.  
  78. ValCheck:Attrs1=FIELDNUM="Felder":2:NR,REQUIRED="Erforderlich":1:NR:VM:BooleanYesNo
  79. ValCheck:Attrs2=MINVALUE="Mindestwert":1:N,MAXVALUE="H÷chstwert":1:N
  80. ValCheck:Attrs3=DEFAULT="Vorgabewert":1:N,PICTURE="Maske":2:N
  81. ValCheck:Name="Felder"
  82.  
  83. Family:Dataset=NAME=String:32,ID=Word,TYPE=Integer,FILENAME=String:261
  84.  
  85. Family:Attrs=TYPE="Typ":1::VM:FamilyMemberType,NAME="Objektname":1
  86. Family:Name=FILENAME
  87.  
  88. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  89. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  90. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  91.  
  92. Reference:Attrs1=TYPE="Referenztyp":1::VM:ReferenceType
  93. Reference:Attrs2=OTHERTABLE="Referenz auf":1:NR
  94. Reference:Attrs3=MODOP="─nderungen":1:NR:VM:ReferenceQual
  95. Reference:Attrs4=DELOP="L÷schen":1:NR:VM:ReferenceQual
  96. Reference:Name=NAME
  97.  
  98. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  99. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  100.  
  101. Security:Attrs1=TYPE="Tabellenrechte":1:NR:VM:PrivilegeType
  102. Security:Attrs2=FAMRIGHTS="Familienrechte":1:NR:VS:FamilyRightsType:$0F
  103. Security:Name=PASSWORD
  104.  
  105. [ODBC Properties]
  106. DriverType:Values=PARADOX="Paradox",DBASE="dBASE"
  107. BooleanYesNo:Values=0="Nein",-1="Ja"
  108. FieldVChecks:Values=0="",1="Hat Gⁿltigkeitsprⁿfungen",2=""
  109. FieldRights:Values=0="Lesen/Schreiben",1="Nur Lesen",2="Leer",3=""
  110. PrimaryIndex:Values=="<PrimΣrschlⁿssel>"
  111. LookupType:Values1=0="Leer",1="Aktuelles Feld",2="Alle entsprechenden"
  112. LookupType:Values2=3="Aktuelles Feld & Nachschlagen",4="Alle entsprechenden & Nachschlagen"
  113. ReferenceType:Values=0="Master",1="Detail"
  114. ReferenceQual:Values=0="Verhindern",1="Weitergeben"
  115. PrivilegeType:Values1=0="Leer",1="Nur Lesen",3="─ndern/Lesen",7="Einfⁿgen/─ndern/Lesen"
  116. PrivilegeType:Values2=15="L÷schen/Einfⁿgen/─ndern/Lesen",31="Alle Rechte",255=""
  117. FamilyRightsType:Values=0="Leer",1="Formular",2="Berichte",4="Gⁿltigkeitsprⁿfungen",8="Einstellungen"
  118.  
  119. ODBC:Objects=O:"Tabellen"=Table,O:"Stored Procedures"=Procedure
  120.  
  121. Table:Attrs1=TYPE="Typ"::NR:VM:DriverType,DATE="Datum",TIME="Zeit",VERSION="Version":2
  122. Table:Attrs2=VALID="Gⁿltig":2::VM:BooleanYesNo,STRUCTURE="Struktur":2
  123. Table:Attrs3=PROTECTED="Geschⁿtzt":2::VM:BooleanYesNo
  124. Table:Name=FILENAME,EXTENSION
  125. Table:Objects1=O:"Felder"=Column,O:"Indizes"=Index,O:"Gⁿltigkeitsprⁿfungen"=ValCheck
  126. Table:Objects2=O:"Referenzielle Bedingungen"=Reference,O:"Sicherheitseinstellungen"=Security
  127.  
  128. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  129. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  130. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  131.  
  132. Column:Attrs1=TYPE="Typ":1:NR,UNITS1="Gr÷▀e":1:N,UNITS2="Skala":1:N
  133. Column:Attrs2=LENGTH="Physikalische LΣnge"
  134. Column:Name=NAME
  135.  
  136. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  137. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  138. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  139. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  140. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  141. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  142.  
  143. Index:Attrs1=NAME=Name:0::VM:PrimaryIndex,TAGNAME=Tag:0,RESTRNUM="Version":2
  144. Index:Attrs2=PRIMARY="PrimΣrschlⁿssel":::VM:BooleanYesNo,UNIQUE="Eindeutig"::NR:VM:BooleanYesNo
  145. Index:Attrs3=AUTO="Gewartet":2::VM:BooleanYesNo
  146. Index:Attrs4=OUTOFDATE="Veraltet":2::VM:BooleanYesNo
  147. Index:Attrs5=FORMAT="Format":2,BLOCKSIZE="Blockgr÷▀e":2
  148. Index:Attrs6=CASEINSENSITIVE="Ohne Gro▀-/Kleinschreibung":2:NR:VM:BooleanYesNo
  149. Index:Attrs7=DESCENDING="Absteigend":2:NR:VM:BooleanYesNo
  150. Index:Attrs8=EXPRESSION="Ausdruck":2:N
  151. Index:Attrs9=CONDITION="Unterbedingung":2:N
  152. Index:Name=Name,Tag
  153.  
  154. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  155. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  156. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  157. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  158.  
  159. ValCheck:Attrs1=FIELDNUM="Felder":2:NR,REQUIRED="Erforderlich":1:NR:VM:BooleanYesNo
  160. ValCheck:Attrs2=MINVALUE="Mindestwert":1:N,MAXVALUE="H÷chstwert":1:N
  161. ValCheck:Attrs3=DEFAULT="Vorgabewert":1:N,PICTURE="Maske":2:N
  162. ValCheck:Name="Felder"
  163.  
  164. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  165. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  166. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  167.  
  168. Reference:Attrs1=TYPE="Referenztyp":1::VM:ReferenceType
  169. Reference:Attrs2=OTHERTABLE="Referenz auf":1:NR
  170. Reference:Attrs3=MODOP="─nderungen":1:NR:VM:ReferenceQual
  171. Reference:Attrs4=DELOP="L÷schen":1:NR:VM:ReferenceQual
  172. Reference:Name=NAME
  173.  
  174. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  175. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  176.  
  177. Security:Attrs1=TYPE="Tabellenrechte":1:NR:VM:PrivilegeType
  178. Security:Attrs2=FAMRIGHTS="Familienrechte":1:NR:VS:FamilyRightsType:$0F
  179. Security:Name=PASSWORD
  180.  
  181. Procedure:Name=NAME
  182.  
  183.  
  184.  
  185.  
  186. [InterBase Properties]
  187. FieldType:Values1=7=SMALLINT,8=INTEGER,9=QUAD,10=FLOAT
  188. FieldType:Values2=11=double,14=CHAR,27=DOUBLE,35=DATE
  189. FieldType:Values3=37=VARCHAR,40=CSTRING,261=BLOB
  190. FieldSubType:Values1=0=,1="Text",2="BLR",3="ACL",4="Bereiche",5="Zusammenfassung"
  191. FieldSubType:Values2=6="Format",7="Transaktionsbeschreibung",8="Beschreibung Externe Datei"
  192. Boolean01:Values=="Nein",0="Nein",1="Ja"
  193. BlankYes:Values=="Ja",1="Nein"
  194. ParameterType:Values=0="Eingabe",1="Ausgabe"
  195. TriggerType:Values1=1=BEFORE INSERT,2=AFTER INSERT,3=BEFORE UPDATE
  196. TriggerType:Values2=4=AFTER UPDATE,5=BEFORE DELETE,6=AFTER DELETE
  197.  
  198. InterBase:Objects1=O:"DomΣnen"=Domain,O:"Tabellen"=Table,O:"Ansichten"=View
  199. InterBase:Objects2=O:"Stored Procedures"=Procedure,O:"Trigger"=Trigger
  200. InterBase:Objects3=O:"Generatoren"=Generator,O:"Exceptions"=Exception
  201.  
  202. Table:Root=RDB$RELATIONS
  203. View:Root=RDB$RELATIONS
  204. Procedure:Root=RDB$PROCEDURES
  205. Trigger:Root=RDB$TRIGGERS
  206. PrimaryKey:Root=RDB$RELATION_CONSTRAINTS
  207. ForeignKey:Root=RDB$RELATION_CONSTRAINTS
  208. UniqueConstraint:Root=RDB$RELATION_CONSTRAINTS
  209. CheckConstraint:Root=RDB$RELATION_CONSTRAINTS
  210. Exception:Root=RDB$EXCEPTIONS
  211. Generator:Root=RDB$GENERATORS
  212. Index:Root=RDB$INDICES
  213. IndexColumn:Root=RDB$INDEX_SEGMENTS
  214. Column:Root=RDB$RELATION_FIELDS
  215. Domain:Root=RDB$FIELDS
  216. Enumeration:Root=RDB$TYPES
  217. FormalParameter:Root=RDB$PROCEDURE_PARAMETERS
  218.  
  219. RDB$RELATIONS:Attrs1=RDB$OWNER_NAME="Besitzer",RDB$DESCRIPTION="Beschreibung"
  220. RDB$RELATIONS:Objects=T:"Spalten"=Column
  221. RDB$RELATIONS:Name=RDB$RELATION_NAME
  222. RDB$RELATIONS:Reference:"Spalten"=RDB$RELATION_NAME=RDB$RELATION_NAME
  223. RDB$RELATIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  224.  
  225. RDB$RELATION_FIELDS:Keys=RDB$FIELD_POSITION
  226. RDB$RELATION_FIELDS:Objects=T:"DomΣne"=Domain
  227. RDB$RELATION_FIELDS:Name=RDB$FIELD_NAME
  228. RDB$RELATION_FIELDS:Reference:"DomΣne"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  229.  
  230. RDB$FIELDS:Objects=T:"Werte"=Enumeration
  231. RDB$FIELDS:Attrs1=RDB$FIELD_TYPE="Typ":::VM:FieldType
  232. RDB$FIELDS:Attrs2=RDB$FIELD_SUB_TYPE="Untertyp":::VM:FieldSubType
  233. RDB$FIELDS:Attrs3=RDB$FIELD_LENGTH="LΣnge",RDB$FIELD_SCALE="Skala"
  234. RDB$FIELDS:Attrs4=RDB$NULL_FLAG="Nullzeichen"::R:VM:BlankYes
  235. RDB$FIELDS:Attrs5=RDB$SEGMENT_LENGTH="Segment-Gr÷▀e":2
  236. RDB$FIELDS:Attrs6=RDB$DEFAULT_SOURCE="Vorgabe":2:R
  237. RDB$FIELDS:Attrs7=RDB$VALIDATION_SOURCE="Randbedingung":2:R
  238. RDB$FIELDS:Attrs8=RDB$DESCRIPTION="Beschreibung"
  239. RDB$FIELDS:Name=RDB$FIELD_NAME
  240. RDB$FIELDS:Reference:"Werte"=RDB$FIELD_NAME=RDB$FIELD_NAME
  241.  
  242. RDB$INDICES:Objects=T:"Spalten"=IndexColumn
  243. RDB$INDICES:Attrs=RDB$UNIQUE_FLAG="Eindeutig":::VM:Boolean01
  244. RDB$INDICES:Name=RDB$INDEX_NAME
  245. RDB$INDICES:Reference:"Spalten"=RDB$INDEX_NAME=RDB$INDEX_NAME
  246. RDB$INDICES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  247.  
  248. RDB$INDEX_SEGMENTS:Keys=RDB$FIELD_POSITION
  249. RDB$INDEX_SEGMENTS:Name=RDB$FIELD_NAME
  250.  
  251. RDB$PROCEDURES:Objects=T:"Parameter"=FormalParameter
  252. RDB$PROCEDURES:Attrs=RDB$OWNER_NAME="Besitzer"
  253. RDB$PROCEDURES:Name=RDB$PROCEDURE_NAME
  254. RDB$PROCEDURES:Reference:"Parameter"=RDB$PROCEDURE_NAME=RDB$PROCEDURE_NAME
  255. RDB$PROCEDURES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  256.  
  257. RDB$PROCEDURE_PARAMETERS:Keys=RDB$PARAMETER_TYPE,RDB$PARAMETER_NUMBER
  258. RDB$PROCEDURE_PARAMETERS:Objects=T:"DomΣne"=Domain
  259. RDB$PROCEDURE_PARAMETERS:Reference:"DomΣne"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  260. RDB$PROCEDURE_PARAMETERS:Attrs=RDB$PARAMETER_TYPE="Parameterart":::VM:ParameterType
  261. RDB$PROCEDURE_PARAMETERS:Name=RDB$PARAMETER_NAME
  262.  
  263. FormalParameter:Attrs:Q1="Typ":2::VM:FieldType
  264. FormalParameter:Attrs:Q2="Untertyp":2::VM:FieldSubType
  265. FormalParameter:Attrs:Q3="LΣnge":2,"Skala":2
  266. FormalParameter:AttrReference:"Typ"1=select RDB$FIELD_TYPE from RDB$FIELDS
  267. FormalParameter:AttrReference:"Typ"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  268. FormalParameter:AttrReference:"Untertyp"1=select RDB$FIELD_SUB_TYPE from RDB$FIELDS
  269. FormalParameter:AttrReference:"Untertyp"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  270. FormalParameter:AttrReference:"LΣnge"1=select RDB$FIELD_LENGTH from RDB$FIELDS
  271. FormalParameter:AttrReference:"LΣnge"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  272. FormalParameter:AttrReference:"Skala"1=select RDB$FIELD_SCALE from RDB$FIELDS
  273. FormalParameter:AttrReference:"Skala"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  274.  
  275. RDB$TYPES:Keys=RDB$TYPE
  276. RDB$TYPES:Attrs=RDB$TYPE="Wert"
  277. RDB$TYPES:Name=RDB$TYPE_NAME
  278. RDB$TYPES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  279.  
  280. RDB$GENERATORS:Name=RDB$GENERATOR_NAME
  281. RDB$GENERATORS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  282.  
  283. Generator:Attrs:Q="Aktueller Wert":2
  284. Generator:AttrReference:"Aktueller Wert"1=select distinct gen_id(%VRDB$GENERATOR_NAME%, 0)
  285. Generator:AttrReference:"Aktueller Wert"2=from RDB$GENERATORS
  286.  
  287. RDB$EXCEPTIONS:Keys=RDB$EXCEPTION_NUMBER
  288. RDB$EXCEPTIONS:Attrs=RDB$EXCEPTION_NUMBER="Code",RDB$MESSAGE="Botschaften"
  289. RDB$EXCEPTIONS:Name=RDB$EXCEPTION_NAME
  290.  
  291. RDB$TRIGGERS:Objects=T:"Tabelle"=Table
  292. RDB$TRIGGERS:Attrs1=RDB$TRIGGER_TYPE="Typ":::VM:TriggerType
  293. RDB$TRIGGERS:Attrs2=RDB$TRIGGER_SEQUENCE="Sequenzen"
  294. RDB$TRIGGERS:Name=RDB$TRIGGER_NAME
  295. RDB$TRIGGERS:Reference:"Tabelle"=RDB$RELATION_NAME=RDB$RELATION_NAME
  296. RDB$TRIGGERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  297.  
  298. RDB$RELATION_CONSTRAINTS:Objects=T:"Tabelle"=Table,T:"Spalten"=IndexColumn
  299. RDB$RELATION_CONSTRAINTS:Attrs1=RDB$DEFERRABLE="Kann verschoben werden"
  300. RDB$RELATION_CONSTRAINTS:Attrs2=RDB$INITIALLY_DEFERRED="AnfΣnglich verschoben"
  301. RDB$RELATION_CONSTRAINTS:Attrs3=RDB$INDEX_NAME="Indizes"
  302. RDB$RELATION_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  303. RDB$RELATION_CONSTRAINTS:Reference:"Tabelle"=RDB$RELATION_NAME=RDB$RELATION_NAME
  304. RDB$RELATION_CONSTRAINTS:Reference:"Spalten"=RDB$INDEX_NAME=RDB$INDEX_NAME
  305.  
  306. RDB$REF_CONSTRAINTS:Objects=T:"PrimΣrschlⁿssel"=PrimaryKey,T:"Fremdschlⁿssel"=ForeignKey
  307. RDB$REF_CONSTRAINTS:Attrs1=RDB$CONSTRAINT_NAME="Fremdschlⁿssel"
  308. RDB$REF_CONSTRAINTS:Attrs2=RDB$CONST_NAME_UQ="PrimΣrschlⁿssel"
  309. RDB$REF_CONSTRAINTS:Attrs3=RDB$MATCH_OPTION="▄bereinstimmungsoptionen"
  310. RDB$REF_CONSTRAINTS:Attrs4=RDB$UPDATE_RULE="Aktualisierungsregel"
  311. RDB$REF_CONSTRAINTS:Attrs5=RDB$DELETE_RULE="L÷schregel"
  312. RDB$REF_CONSTRAINTS:Name=RDB$CONST_NAME_UQ
  313. RDB$REF_CONSTRAINTS:Reference:"PrimΣrschlⁿssel"=RDB$CONST_NAME_UQ=RDB$CONSTRAINT_NAME
  314. RDB$REF_CONSTRAINTS:Reference:"Fremdschlⁿssel"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  315.  
  316. RDB$CHECK_CONSTRAINTS:Attrs=RDB$TRIGGER_NAME="Trigger"
  317. RDB$CHECK_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  318.  
  319. Table:Values=RDB$VIEW_SOURCE:is null
  320. Table:Objects1=T:"Indizes"=Index,T:"PrimΣrschlⁿssel"=PrimaryKey
  321. Table:Objects2=T:"Fremdschlⁿssel"=ForeignKey,T:"Eingabebedingungen"=CheckConstraint
  322. Table:Objects3=T:"Eindeutigkeitsbedingungen"=UniqueConstraint,T:"Trigger"=Trigger
  323. Table:Actions=Data
  324. Table:Reference:"Indizes"=RDB$RELATION_NAME=RDB$RELATION_NAME
  325. Table:Reference:"PrimΣrschlⁿssel"=RDB$RELATION_NAME=RDB$RELATION_NAME
  326. Table:Reference:"Fremdschlⁿssel"=RDB$RELATION_NAME=RDB$RELATION_NAME
  327. Table:Reference:"Eingabebedingungen"=RDB$RELATION_NAME=RDB$RELATION_NAME
  328. Table:Reference:"Eindeutigkeitsbedingungen"=RDB$RELATION_NAME=RDB$RELATION_NAME
  329. Table:Reference:"Trigger"=RDB$RELATION_NAME=RDB$RELATION_NAME
  330. Table:Actions:Delete=DROP TABLE %N%
  331. Table:Actions:Save=COMMIT
  332.  
  333. View:Values=RDB$VIEW_SOURCE:is not null
  334. View:Actions=Data
  335. View:Attrs:Q="Text"
  336. View:AttrReference:"Text"1=select RDB$VIEW_SOURCE from RDB$RELATIONS
  337. View:AttrReference:"Text"2=where RDB$RELATION_ID=%CRDB$RELATION_ID%
  338. View:Actions:Delete=DROP VIEW %N%
  339. View:Actions:Save=COMMIT
  340.  
  341. Column:Attrs:T1=RDB$FIELDS.RDB$FIELD_SCALE="Skala":RDB$RELATION_NAME
  342. Column:Attrs:T2=RDB$FIELDS.RDB$FIELD_LENGTH="LΣnge":"Skala"
  343. Column:Attrs:T3=RDB$FIELDS.RDB$FIELD_SUB_TYPE="Untertyp":"LΣnge"
  344. Column:Attrs:T4=RDB$FIELDS.RDB$FIELD_TYPE="Typ":"Untertyp"
  345. Column:AttrReference:"Skala"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  346. Column:AttrReference:"LΣnge"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  347. Column:AttrReference:"Untertyp"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  348. Column:AttrReference:"Typ"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  349.  
  350. Procedure:Actions=
  351. Procedure:Attrs:Q="Text"
  352. Procedure:AttrReference:"Text"1=select RDB$PROCEDURE_SOURCE from RDB$PROCEDURES
  353. Procedure:AttrReference:"Text"2=where RDB$PROCEDURE_NAME=%CRDB$PROCEDURE_NAME%
  354.  
  355. UniqueConstraint:Values=RDB$CONSTRAINT_TYPE:=UNIQUE
  356.  
  357. CheckConstraint:Values=RDB$CONSTRAINT_TYPE:=CHECK
  358. CheckConstraint:Attrs:Q="Text"
  359. CheckConstraint:AttrReference:"Text"1=select t.RDB$TRIGGER_SOURCE
  360. CheckConstraint:AttrReference:"Text"2=from RDB$TRIGGERS t, RDB$CHECK_CONSTRAINTS c
  361. CheckConstraint:AttrReference:"Text"3=where t.RDB$TRIGGER_NAME=c.RDB$TRIGGER_NAME and
  362. CheckConstraint:AttrReference:"Text"4=t.RDB$TRIGGER_TYPE=1 and
  363. CheckConstraint:AttrReference:"Text"5=c.RDB$CONSTRAINT_NAME=%CRDB$CONSTRAINT_NAME%
  364.  
  365. PrimaryKey:Values=RDB$CONSTRAINT_TYPE:=PRIMARY KEY
  366.  
  367. ForeignKey:Values=RDB$CONSTRAINT_TYPE:=FOREIGN KEY
  368. ForeignKey:Attrs:T1=RDB$REF_CONSTRAINTS.RDB$MATCH_OPTION="▄bereinstimmungsoptionen"
  369. ForeignKey:Attrs:T2=RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE="Aktualisierungsregel"
  370. ForeignKey:Attrs:T3=RDB$REF_CONSTRAINTS.RDB$DELETE_RULE="L÷schregel"
  371. ForeignKey:AttrReference:"▄bereinstimmungsoptionen"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  372. ForeignKey:AttrReference:"Aktualisierungsregel"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  373. ForeignKey:AttrReference:"L÷schregel"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  374.  
  375. Trigger:Actions=
  376. Trigger:Attrs:Q="Text"
  377. Trigger:AttrReference:"Text"1=select RDB$TRIGGER_SOURCE from RDB$TRIGGERS
  378. Trigger:AttrReference:"Text"2=where RDB$TRIGGER_NAME=%CRDB$TRIGGER_NAME%
  379.  
  380.  
  381.